/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.100.211
 Source Server Type    : MySQL
 Source Server Version : 50614
 Source Host           : 192.168.100.211
 Source Database       : exam

 Target Server Type    : MySQL
 Target Server Version : 50614
 File Encoding         : utf-8

 Date: 01/17/2019 14:10:27 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `t_follow`
-- ----------------------------
DROP TABLE IF EXISTS `t_follow`;
CREATE TABLE `t_follow` (
  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `FOLLOW` varchar(100) DEFAULT NULL COMMENT '访视内容',
  `IF_DEL` tinyint(2) DEFAULT NULL COMMENT '是否删除 1 是  0否',
  `DT_FOLLOW` date DEFAULT NULL COMMENT '随访日期',
  `PATIENT_ID` int(11) DEFAULT NULL COMMENT '患者外键',
  PRIMARY KEY (`ID`),
  KEY `PATIENT_ID` (`PATIENT_ID`),
  CONSTRAINT `fk_follow` FOREIGN KEY (`PATIENT_ID`) REFERENCES `t_patient` (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=636 DEFAULT CHARSET=utf8 COMMENT='患者随访表';

-- ----------------------------
--  Records of `t_follow`
-- ----------------------------
BEGIN;
INSERT INTO `t_follow` VALUES ('1', '测试随访1', '1', '2018-03-08', '9'), ('2', '测试随访2', '0', '2018-07-13', '9'), ('3', '测试随访3', '0', '2018-05-23', '9'), ('4', '测试随访4', '0', '2018-07-26', '19'), ('5', '测试随访5', '0', '2018-04-04', '23'), ('6', '测试随访6', '1', '2018-01-10', '23'), ('7', '测试随访7', '0', '2018-08-12', '17'), ('8', '测试随访8', '0', '2018-10-31', '11'), ('9', '测试随访9', '0', '2018-04-30', '19'), ('10', '测试随访10', '0', '2018-06-02', '22'), ('11', '测试随访11', '0', '2018-01-17', '17'), ('12', '测试随访12', '0', '2018-07-13', '16'), ('13', '测试随访13', '0', '2018-06-23', '17'), ('14', '测试随访14', '0', '2018-09-28', '9'), ('15', '测试随访15', '0', '2018-07-01', '9'), ('16', '测试随访16', '0', '2018-01-05', '19'), ('17', '测试随访17', '0', '2018-04-12', '15'), ('18', '测试随访18', '0', '2018-06-10', '14'), ('19', '测试随访19', '0', '2018-03-22', '29'), ('20', '测试随访20', '1', '2018-01-16', '20'), ('21', '测试随访21', '0', '2018-07-19', '18'), ('22', '测试随访22', '0', '2018-05-03', '29'), ('23', '测试随访23', '0', '2018-09-22', '23'), ('24', '测试随访24', '0', '2018-09-03', '8'), ('25', '测试随访25', '0', '2018-07-17', '17'), ('26', '测试随访26', '0', '2018-07-04', '17'), ('27', '测试随访27', '0', '2018-07-31', '22'), ('28', '测试随访28', '0', '2018-05-10', '9'), ('29', '测试随访29', '0', '2018-12-01', '14'), ('30', '测试随访30', '0', '2018-03-20', '9'), ('31', '测试随访31', '0', '2018-08-08', '8'), ('32', '测试随访32', '0', '2018-04-26', '9'), ('33', '测试随访33', '1', '2018-08-21', '9'), ('34', '测试随访34', '0', '2018-07-01', '8'), ('35', '测试随访35', '0', '2018-12-02', '9'), ('36', '测试随访36', '0', '2018-11-12', '3'), ('37', '测试随访37', '0', '2018-06-05', '9'), ('38', '测试随访38', '0', '2018-03-20', '10'), ('39', '测试随访39', '0', '2018-08-24', '19'), ('40', '测试随访40', '0', '2018-07-26', '8'), ('41', '测试随访41', '0', '2018-01-15', '21'), ('42', '测试随访42', '0', '2018-07-26', '9'), ('43', '测试随访43', '0', '2018-09-16', '9'), ('44', '测试随访44', '0', '2018-01-19', '29'), ('45', '测试随访45', '0', '2018-07-30', '17'), ('46', '测试随访46', '1', '2018-05-23', '10'), ('47', '测试随访47', '0', '2018-04-02', '10'), ('48', '测试随访48', '0', '2018-03-08', '8'), ('49', '测试随访49', '0', '2018-04-15', '17'), ('50', '测试随访50', '0', '2018-04-13', '8'), ('51', '测试随访51', '0', '2018-10-23', '23'), ('52', '测试随访52', '0', '2018-04-15', '16'), ('53', '测试随访53', '0', '2018-07-11', '21'), ('54', '测试随访54', '0', '2018-12-15', '7'), ('55', '测试随访55', '0', '2018-06-28', '23'), ('56', '测试随访56', '0', '2018-10-13', '25'), ('57', '测试随访57', '0', '2018-07-28', '29'), ('58', '测试随访58', '0', '2018-01-19', '9'), ('59', '测试随访59', '0', '2018-06-27', '19'), ('60', '测试随访60', '0', '2018-01-06', '9'), ('61', '测试随访61', '0', '2018-05-23', '8'), ('62', '测试随访62', '0', '2018-01-30', '8'), ('63', '测试随访63', '0', '2018-05-02', '23'), ('64', '测试随访64', '0', '2018-02-24', '8'), ('65', '测试随访65', '0', '2018-03-06', '23'), ('66', '测试随访66', '0', '2018-04-13', '14'), ('67', '测试随访67', '0', '2018-01-30', '9'), ('68', '测试随访68', '0', '2018-10-04', '1'), ('69', '测试随访69', '0', '2018-08-28', '29'), ('70', '测试随访70', '0', '2018-03-03', '19'), ('71', '测试随访71', '0', '2018-06-29', '29'), ('72', '测试随访72', '0', '2018-05-10', '10'), ('73', '测试随访73', '0', '2018-11-07', '24'), ('74', '测试随访74', '0', '2018-02-02', '10'), ('75', '测试随访75', '0', '2018-09-22', '7'), ('76', '测试随访76', '0', '2018-12-15', '10'), ('77', '测试随访77', '0', '2018-01-06', '8'), ('78', '测试随访78', '0', '2018-04-26', '8'), ('79', '测试随访79', '0', '2018-08-25', '7'), ('80', '测试随访80', '0', '2018-07-02', '22'), ('81', '测试随访81', '0', '2018-08-25', '17'), ('82', '测试随访82', '0', '2018-03-24', '7'), ('83', '测试随访83', '0', '2018-10-09', '21'), ('84', '测试随访84', '0', '2018-10-10', '20'), ('85', '测试随访85', '0', '2018-06-18', '7'), ('86', '测试随访86', '0', '2018-10-28', '27'), ('87', '测试随访87', '0', '2018-04-14', '20'), ('88', '测试随访88', '1', '2018-08-21', '8'), ('89', '测试随访89', '0', '2018-04-26', '10'), ('90', '测试随访90', '0', '2018-01-17', '16'), ('91', '测试随访91', '0', '2018-04-13', '10'), ('92', '测试随访92', '0', '2018-06-18', '10'), ('93', '测试随访93', '0', '2018-05-29', '19'), ('94', '测试随访94', '0', '2018-09-03', '9'), ('95', '测试随访95', '0', '2018-01-25', '7'), ('96', '测试随访96', '0', '2018-05-10', '8'), ('97', '测试随访97', '0', '2018-02-03', '19'), ('98', '测试随访98', '0', '2018-05-12', '14'), ('99', '测试随访99', '0', '2018-09-20', '17'), ('100', '测试随访100', '0', '2018-09-29', '22'), ('101', '测试随访101', '0', '2018-01-30', '29'), ('102', '测试随访102', '0', '2018-09-28', '8'), ('103', '测试随访103', '0', '2018-02-08', '23'), ('104', '测试随访104', '0', '2018-07-28', '7'), ('105', '测试随访105', '1', '2018-07-01', '10'), ('106', '测试随访106', '0', '2018-09-30', '12'), ('107', '测试随访107', '0', '2018-04-23', '7'), ('108', '测试随访108', '0', '2018-06-05', '8'), ('109', '测试随访109', '0', '2018-07-09', '14'), ('110', '测试随访110', '0', '2018-09-22', '19'), ('111', '测试随访111', '0', '2018-03-08', '10'), ('112', '测试随访112', '0', '2018-10-09', '16'), ('113', '测试随访113', '0', '2018-06-05', '10'), ('114', '测试随访114', '0', '2018-01-17', '15'), ('115', '测试随访115', '0', '2018-05-07', '7'), ('116', '测试随访116', '0', '2018-02-14', '14'), ('117', '测试随访117', '0', '2018-09-28', '29'), ('118', '测试随访118', '0', '2018-08-31', '22'), ('119', '测试随访119', '0', '2018-06-01', '29'), ('120', '测试随访120', '0', '2018-10-07', '15'), ('121', '测试随访121', '0', '2018-10-27', '29'), ('122', '测试随访122', '0', '2018-04-13', '21'), ('123', '测试随访123', '0', '2018-08-08', '9'), ('124', '测试随访124', '0', '2018-05-30', '23'), ('125', '测试随访125', '0', '2018-08-11', '7'), ('126', '测试随访126', '0', '2018-09-16', '8'), ('127', '测试随访127', '0', '2018-09-05', '14'), ('128', '测试随访128', '0', '2018-10-28', '28'), ('129', '测试随访129', '0', '2018-06-04', '7'), ('130', '测试随访130', '0', '2018-09-07', '17'), ('131', '测试随访131', '0', '2018-09-08', '7'), ('132', '测试随访132', '0', '2018-04-02', '8'), ('133', '测试随访133', '0', '2018-07-16', '7'), ('134', '测试随访134', '0', '2018-04-02', '9'), ('135', '测试随访135', '0', '2018-11-24', '26'), ('136', '测试随访136', '0', '2018-06-18', '8'), ('137', '测试随访137', '0', '2018-08-08', '10'), ('138', '测试随访138', '0', '2018-07-12', '20'), ('139', '测试随访139', '0', '2018-08-07', '14'), ('140', '测试随访140', '0', '2018-06-18', '9'), ('141', '测试随访141', '0', '2018-11-02', '2'), ('142', '测试随访142', '0', '2018-07-13', '10'), ('143', '测试随访143', '0', '2018-07-26', '23'), ('144', '测试随访144', '0', '2018-02-12', '8'), ('145', '测试随访145', '0', '2018-11-17', '17'), ('146', '测试随访146', '1', '2018-08-21', '10'), ('147', '测试随访147', '0', '2018-07-02', '7'), ('148', '测试随访148', '0', '2018-10-20', '6'), ('149', '测试随访149', '0', '2018-07-13', '8'), ('150', '测试随访150', '0', '2018-12-15', '8'), ('151', '测试随访151', '0', '2018-12-18', '5'), ('152', '测试随访152', '0', '2018-12-18', '5'), ('153', '测试随访153', '0', '2018-12-18', '5'), ('154', '测试随访154', '0', '2018-12-18', '5'), ('155', '测试随访155', '0', '2018-12-18', '5'), ('156', '测试随访156', '0', '2018-12-18', '5'), ('157', '测试随访157', '0', '2018-12-18', '5'), ('158', '测试随访158', '0', '2018-12-18', '5'), ('159', '测试随访159', '0', '2018-12-18', '5'), ('160', '测试随访160', '0', '2018-12-18', '5'), ('161', '测试随访161', '0', '2018-12-18', '5'), ('162', '测试随访162', '0', '2018-10-20', '6'), ('163', '测试随访163', '0', '2018-10-20', '6'), ('164', '测试随访164', '0', '2018-10-20', '6'), ('165', '测试随访165', '0', '2018-10-20', '6'), ('166', '测试随访166', '0', '2018-10-20', '6'), ('167', '测试随访167', '0', '2018-10-20', '6'), ('168', '测试随访168', '0', '2018-10-24', '6'), ('169', '测试随访169', '0', '2018-10-24', '6'), ('170', '测试随访170', '0', '2018-10-24', '6'), ('171', '测试随访171', '0', '2018-10-24', '6'), ('172', '测试随访172', '0', '2018-10-24', '6'), ('173', '测试随访173', '0', '2018-10-24', '6'), ('174', '测试随访174', '0', '2018-10-24', '6'), ('175', '测试随访175', '0', '2018-11-19', '6'), ('176', '测试随访176', '0', '2018-11-19', '6'), ('177', '测试随访177', '0', '2018-11-19', '6'), ('178', '测试随访178', '0', '2018-11-19', '6'), ('179', '测试随访179', '0', '2018-12-18', '6'), ('180', '测试随访180', '0', '2018-12-18', '6'), ('181', '测试随访181', '0', '2018-12-18', '6'), ('182', '测试随访182', '0', '2018-12-18', '6'), ('183', '测试随访183', '0', '2018-12-18', '6'), ('184', '测试随访184', '0', '2018-12-18', '6'), ('185', '测试随访185', '0', '2018-12-18', '6'), ('186', '测试随访186', '0', '2018-08-24', '23'), ('187', '测试随访187', '0', '2018-12-18', '19'), ('188', '测试随访188', '0', '2018-10-28', '22'), ('189', '测试随访189', '0', '2018-02-23', '29'), ('190', '测试随访190', '0', '2018-02-24', '7'), ('191', '测试随访191', '0', '2018-09-03', '10'), ('192', '测试随访192', '0', '2018-12-18', '5'), ('193', '测试随访193', '0', '2018-12-18', '5'), ('194', '测试随访194', '0', '2018-12-18', '5'), ('195', '测试随访195', '0', '2018-11-19', '6'), ('196', '测试随访196', '0', '2018-11-19', '6'), ('197', '测试随访197', '0', '2018-11-19', '6'), ('198', '测试随访198', '0', '2018-12-18', '6'), ('199', '测试随访199', '0', '2018-12-18', '6'), ('200', '测试随访200', '0', '2018-12-18', '6'), ('201', '测试随访201', '0', '2018-04-13', '9'), ('202', '测试随访202', '0', '2018-01-17', '14'), ('203', '测试随访203', '0', '2018-07-07', '18'), ('204', '测试随访204', '0', '2018-02-12', '10'), ('205', '测试随访205', '0', '2018-04-01', '19'), ('206', '测试随访206', '0', '2018-02-24', '9'), ('207', '测试随访207', '0', '2018-05-03', '22'), ('208', '测试随访208', '0', '2018-05-21', '7'), ('209', '测试随访209', '0', '2018-10-07', '18'), ('210', '测试随访210', '0', '2018-11-08', '4'), ('211', '测试随访211', '0', '2018-03-20', '8'), ('212', '测试随访212', '0', '2018-10-23', '13'), ('213', '测试随访213', '0', '2018-12-18', '5'), ('214', '测试随访214', '0', '2018-02-12', '9'), ('215', '测试随访215', '0', '2018-07-09', '15'), ('216', '测试随访216', '0', '2018-01-19', '8'), ('217', '测试随访217', '0', '2018-03-15', '14'), ('218', '测试随访218', '0', '2018-07-26', '10'), ('219', '测试随访219', '0', '2018-10-28', '27'), ('220', '测试随访220', '0', '2018-10-28', '27'), ('221', '测试随访221', '0', '2018-09-30', '12'), ('222', '测试随访222', '0', '2018-09-30', '12'), ('223', '测试随访223', '0', '2018-09-30', '12'), ('224', '测试随访224', '0', '2018-09-30', '12'), ('225', '测试随访225', '0', '2018-09-30', '12'), ('226', '测试随访226', '0', '2018-10-23', '13'), ('227', '测试随访227', '0', '2018-10-23', '13'), ('228', '测试随访228', '0', '2018-10-23', '13'), ('229', '测试随访229', '0', '2018-10-23', '13'), ('230', '测试随访230', '0', '2018-10-23', '13'), ('231', '测试随访231', '0', '2018-10-23', '13'), ('232', '测试随访232', '0', '2018-10-23', '13'), ('233', '测试随访233', '0', '2018-10-23', '13'), ('234', '测试随访234', '0', '2018-10-23', '13'), ('235', '测试随访235', '0', '2018-10-23', '13'), ('236', '测试随访236', '0', '2018-10-28', '27'), ('237', '测试随访237', '0', '2018-10-28', '27'), ('238', '测试随访238', '0', '2018-10-30', '27'), ('239', '测试随访239', '0', '2018-10-30', '27'), ('240', '测试随访240', '0', '2018-10-30', '27'), ('241', '测试随访241', '0', '2018-10-30', '27'), ('242', '测试随访242', '0', '2018-11-26', '27'), ('243', '测试随访243', '0', '2018-11-26', '27'), ('244', '测试随访244', '0', '2018-11-26', '27'), ('245', '测试随访245', '0', '2018-11-26', '27'), ('246', '测试随访246', '0', '2018-11-26', '27'), ('247', '测试随访247', '0', '2018-11-26', '27'), ('248', '测试随访248', '0', '2018-11-26', '27'), ('249', '测试随访249', '0', '2018-11-26', '27'), ('250', '测试随访250', '0', '2018-11-26', '27'), ('251', '测试随访251', '0', '2018-11-26', '27'), ('252', '测试随访252', '0', '2018-12-20', '26'), ('253', '测试随访253', '0', '2018-12-20', '26'), ('254', '测试随访254', '0', '2018-12-20', '26'), ('255', '测试随访255', '0', '2018-12-20', '26'), ('256', '测试随访256', '0', '2018-12-20', '26'), ('257', '测试随访257', '0', '2018-12-20', '26'), ('258', '测试随访258', '0', '2018-12-20', '26'), ('259', '测试随访259', '0', '2018-12-20', '26'), ('260', '测试随访260', '0', '2018-12-20', '26'), ('261', '测试随访261', '0', '2018-12-20', '26'), ('262', '测试随访262', '0', '2018-11-24', '26'), ('263', '测试随访263', '0', '2018-12-07', '26'), ('264', '测试随访264', '0', '2018-11-08', '4'), ('265', '测试随访265', '0', '2018-09-30', '12'), ('266', '测试随访266', '0', '2018-09-30', '12'), ('267', '测试随访267', '0', '2018-09-30', '12'), ('268', '测试随访268', '0', '2018-09-30', '12'), ('269', '测试随访269', '0', '2018-09-30', '12'), ('270', '测试随访270', '0', '2018-11-21', '4'), ('271', '测试随访271', '0', '2018-12-17', '4'), ('272', '测试随访272', '0', '2018-12-17', '4'), ('273', '测试随访273', '0', '2018-12-17', '4'), ('274', '测试随访274', '0', '2018-12-17', '4'), ('275', '测试随访275', '0', '2018-12-17', '4'), ('276', '测试随访276', '0', '2018-12-17', '4'), ('277', '测试随访277', '0', '2018-11-21', '4'), ('278', '测试随访278', '0', '2018-12-04', '4'), ('279', '测试随访279', '0', '2018-12-17', '4'), ('280', '测试随访280', '0', '2018-10-31', '11'), ('281', '测试随访281', '0', '2018-10-31', '11'), ('282', '测试随访282', '0', '2018-10-31', '11'), ('283', '测试随访283', '0', '2018-10-31', '11'), ('284', '测试随访284', '0', '2018-10-31', '11'), ('285', '测试随访285', '0', '2018-10-31', '11'), ('286', '测试随访286', '0', '2018-10-31', '11'), ('287', '测试随访287', '0', '2018-10-31', '11'), ('288', '测试随访288', '0', '2018-10-31', '11'), ('289', '测试随访289', '0', '2018-10-13', '25'), ('290', '测试随访290', '0', '2018-10-13', '25'), ('291', '测试随访291', '0', '2018-10-13', '25'), ('292', '测试随访292', '0', '2018-10-13', '25'), ('293', '测试随访293', '0', '2018-10-13', '25'), ('294', '测试随访294', '0', '2018-10-13', '25'), ('295', '测试随访295', '0', '2018-10-13', '25'), ('296', '测试随访296', '0', '2018-10-13', '25'), ('297', '测试随访297', '0', '2018-10-13', '25'), ('298', '测试随访298', '0', '2018-10-13', '25'), ('299', '测试随访299', '0', '2018-11-07', '24'), ('300', '测试随访300', '0', '2018-11-07', '24'), ('301', '测试随访301', '0', '2018-11-07', '24'), ('302', '测试随访302', '0', '2018-11-07', '24'), ('303', '测试随访303', '0', '2018-11-12', '24'), ('304', '测试随访304', '0', '2018-11-12', '24'), ('305', '测试随访305', '0', '2018-10-27', '29'), ('306', '测试随访306', '0', '2018-10-27', '29'), ('307', '测试随访307', '0', '2018-10-27', '29'), ('308', '测试随访308', '0', '2018-12-10', '24'), ('309', '测试随访309', '0', '2018-12-10', '24'), ('310', '测试随访310', '0', '2018-12-10', '24'), ('311', '测试随访311', '0', '2018-12-06', '29'), ('312', '测试随访312', '0', '2018-12-06', '29'), ('313', '测试随访313', '0', '2018-12-06', '29'), ('314', '测试随访314', '0', '2018-12-06', '29'), ('315', '测试随访315', '0', '2018-12-06', '29'), ('316', '测试随访316', '0', '2018-12-06', '29'), ('317', '测试随访317', '0', '2018-12-06', '29'), ('318', '测试随访318', '0', '2018-12-06', '29'), ('319', '测试随访319', '0', '2018-12-06', '29'), ('320', '测试随访320', '0', '2018-12-06', '29'), ('321', '测试随访321', '0', '2018-10-07', '18'), ('322', '测试随访322', '0', '2018-10-07', '18'), ('323', '测试随访323', '0', '2018-12-03', '18'), ('324', '测试随访324', '0', '2018-12-03', '18'), ('325', '测试随访325', '0', '2018-12-03', '18'), ('326', '测试随访326', '0', '2018-12-03', '18'), ('327', '测试随访327', '0', '2018-12-03', '18'), ('328', '测试随访328', '0', '2018-12-03', '18'), ('329', '测试随访329', '0', '2018-12-03', '18'), ('330', '测试随访330', '0', '2018-12-03', '18'), ('331', '测试随访331', '0', '2018-12-03', '18'), ('332', '测试随访332', '0', '2018-12-03', '18'), ('333', '测试随访333', '0', '2018-11-12', '24'), ('334', '测试随访334', '0', '2018-12-10', '24'), ('335', '测试随访335', '0', '2018-12-10', '24'), ('336', '测试随访336', '0', '2018-12-10', '24'), ('337', '测试随访337', '0', '2018-12-10', '24'), ('338', '测试随访338', '0', '2018-12-10', '24'), ('339', '测试随访339', '0', '2018-12-10', '24'), ('340', '测试随访340', '0', '2018-12-01', '14'), ('341', '测试随访341', '0', '2018-12-01', '14'), ('342', '测试随访342', '0', '2018-12-01', '14'), ('343', '测试随访343', '0', '2018-12-01', '14'), ('344', '测试随访344', '0', '2018-12-01', '14'), ('345', '测试随访345', '0', '2018-12-01', '14'), ('346', '测试随访346', '0', '2018-12-01', '14'), ('347', '测试随访347', '0', '2018-10-09', '16'), ('348', '测试随访348', '0', '2018-10-09', '16'), ('349', '测试随访349', '0', '2018-10-09', '16'), ('350', '测试随访350', '0', '2018-10-09', '16'), ('351', '测试随访351', '0', '2018-10-09', '16'), ('352', '测试随访352', '0', '2018-12-16', '16'), ('353', '测试随访353', '0', '2018-12-16', '16'), ('354', '测试随访354', '0', '2018-12-16', '16'), ('355', '测试随访355', '0', '2018-12-16', '16'), ('356', '测试随访356', '0', '2018-12-01', '14'), ('357', '测试随访357', '0', '2018-12-01', '14'), ('358', '测试随访358', '0', '2018-12-01', '14'), ('359', '测试随访359', '0', '2018-12-16', '16'), ('360', '测试随访360', '0', '2018-12-16', '16'), ('361', '测试随访361', '0', '2018-12-16', '16'), ('362', '测试随访362', '0', '2018-12-16', '16'), ('363', '测试随访363', '0', '2018-12-16', '16'), ('364', '测试随访364', '0', '2018-10-09', '16'), ('365', '测试随访365', '0', '2018-10-07', '15'), ('366', '测试随访366', '0', '2018-10-07', '15'), ('367', '测试随访367', '0', '2018-10-18', '15'), ('368', '测试随访368', '0', '2018-10-18', '15'), ('369', '测试随访369', '0', '2018-11-01', '15'), ('370', '测试随访370', '0', '2018-11-01', '15'), ('371', '测试随访371', '0', '2018-11-16', '15'), ('372', '测试随访372', '0', '2018-11-16', '15'), ('373', '测试随访373', '0', '2018-12-10', '15'), ('374', '测试随访374', '0', '2018-12-10', '15'), ('375', '测试随访375', '0', '2018-12-10', '15'), ('376', '测试随访376', '0', '2018-12-10', '15'), ('377', '测试随访377', '0', '2018-12-10', '15'), ('378', '测试随访378', '0', '2018-12-10', '15'), ('379', '测试随访379', '0', '2018-12-10', '15'), ('380', '测试随访380', '0', '2018-12-10', '15'), ('381', '测试随访381', '0', '2018-12-10', '15'), ('382', '测试随访382', '0', '2018-12-10', '15'), ('383', '测试随访383', '0', '2018-12-22', '19'), ('384', '测试随访384', '0', '2018-12-22', '19'), ('385', '测试随访385', '0', '2018-12-22', '19'), ('386', '测试随访386', '0', '2018-12-22', '19'), ('387', '测试随访387', '0', '2018-12-22', '19'), ('388', '测试随访388', '0', '2018-12-22', '19'), ('389', '测试随访389', '0', '2018-12-22', '19'), ('390', '测试随访390', '0', '2018-10-04', '1'), ('391', '测试随访391', '0', '2018-10-04', '1'), ('392', '测试随访392', '0', '2018-10-04', '1'), ('393', '测试随访393', '0', '2018-10-04', '1'), ('394', '测试随访394', '0', '2018-10-04', '1'), ('395', '测试随访395', '0', '2018-10-21', '1'), ('396', '测试随访396', '0', '2018-10-21', '1'), ('397', '测试随访397', '0', '2018-10-21', '1'), ('398', '测试随访398', '0', '2018-10-21', '1'), ('399', '测试随访399', '0', '2018-11-20', '1'), ('400', '测试随访400', '0', '2018-11-20', '1'), ('401', '测试随访401', '0', '2018-11-20', '1'), ('402', '测试随访402', '0', '2018-11-20', '1'), ('403', '测试随访403', '0', '2018-11-20', '1'), ('404', '测试随访404', '0', '2018-11-20', '1'), ('405', '测试随访405', '0', '2018-10-10', '20'), ('406', '测试随访406', '0', '2018-10-10', '20'), ('407', '测试随访407', '0', '2018-10-10', '20'), ('408', '测试随访408', '0', '2018-10-19', '20'), ('409', '测试随访409', '0', '2018-10-19', '20'), ('410', '测试随访410', '0', '2018-10-19', '20'), ('411', '测试随访411', '0', '2018-10-19', '20'), ('412', '测试随访412', '0', '2018-10-19', '20'), ('413', '测试随访413', '0', '2018-10-19', '20'), ('414', '测试随访414', '0', '2018-10-19', '20'), ('415', '测试随访415', '0', '2018-10-19', '20'), ('416', '测试随访416', '0', '2018-10-19', '20'), ('417', '测试随访417', '0', '2018-10-19', '20'), ('418', '测试随访418', '0', '2018-11-20', '1'), ('419', '测试随访419', '0', '2018-11-20', '1'), ('420', '测试随访420', '0', '2018-11-20', '1'), ('421', '测试随访421', '0', '2018-11-20', '1'), ('422', '测试随访422', '0', '2018-12-18', '19'), ('423', '测试随访423', '0', '2018-12-18', '19'), ('424', '测试随访424', '0', '2018-12-18', '19'), ('425', '测试随访425', '0', '2018-12-18', '19'), ('426', '测试随访426', '0', '2018-12-22', '19'), ('427', '测试随访427', '0', '2018-11-27', '22'), ('428', '测试随访428', '0', '2018-10-09', '21'), ('429', '测试随访429', '0', '2018-10-09', '21'), ('430', '测试随访430', '0', '2018-11-07', '21'), ('431', '测试随访431', '0', '2018-11-07', '21'), ('432', '测试随访432', '0', '2018-12-19', '21'), ('433', '测试随访433', '0', '2018-12-19', '21'), ('434', '测试随访434', '0', '2018-12-19', '21'), ('435', '测试随访435', '0', '2018-12-19', '21'), ('436', '测试随访436', '0', '2018-12-19', '21'), ('437', '测试随访437', '0', '2018-12-19', '21'), ('438', '测试随访438', '0', '2018-12-19', '21'), ('439', '测试随访439', '0', '2018-12-19', '21'), ('440', '测试随访440', '0', '2018-12-19', '21'), ('441', '测试随访441', '0', '2018-10-28', '22'), ('442', '测试随访442', '0', '2018-11-27', '22'), ('443', '测试随访443', '0', '2018-11-27', '22'), ('444', '测试随访444', '0', '2018-11-27', '22'), ('445', '测试随访445', '0', '2018-11-27', '22'), ('446', '测试随访446', '0', '2018-11-27', '22'), ('447', '测试随访447', '0', '2018-11-27', '22'), ('448', '测试随访448', '0', '2018-11-27', '22'), ('449', '测试随访449', '0', '2018-11-27', '22'), ('450', '测试随访450', '0', '2018-12-16', '23'), ('451', '测试随访451', '0', '2018-12-16', '23'), ('452', '测试随访452', '0', '2018-12-16', '23'), ('453', '测试随访453', '0', '2018-11-18', '23'), ('454', '测试随访454', '0', '2018-11-18', '23'), ('455', '测试随访455', '0', '2018-11-18', '23'), ('456', '测试随访456', '0', '2018-11-18', '23'), ('457', '测试随访457', '0', '2018-12-16', '23'), ('458', '测试随访458', '0', '2018-12-16', '23'), ('459', '测试随访459', '0', '2018-12-16', '23'), ('460', '测试随访460', '0', '2018-12-16', '23'), ('461', '测试随访461', '0', '2018-12-16', '23'), ('462', '测试随访462', '0', '2018-12-16', '23'), ('463', '测试随访463', '0', '2018-12-16', '23'), ('464', '测试随访464', '0', '2018-11-17', '17'), ('465', '测试随访465', '0', '2018-11-17', '17'), ('466', '测试随访466', '0', '2018-11-17', '17'), ('467', '测试随访467', '0', '2018-11-17', '17'), ('468', '测试随访468', '0', '2018-11-17', '17'), ('469', '测试随访469', '0', '2018-11-30', '17'), ('470', '测试随访470', '0', '2018-11-30', '17'), ('471', '测试随访471', '0', '2018-11-30', '17'), ('472', '测试随访472', '0', '2018-11-30', '17'), ('473', '测试随访473', '0', '2018-11-30', '17'), ('474', '测试随访474', '0', '2018-12-13', '17'), ('475', '测试随访475', '0', '2018-12-13', '17'), ('476', '测试随访476', '0', '2018-12-13', '17'), ('477', '测试随访477', '0', '2018-10-23', '23'), ('478', '测试随访478', '0', '2018-10-23', '23'), ('479', '测试随访479', '0', '2018-10-23', '23'), ('480', '测试随访480', '0', '2018-10-23', '23'), ('481', '测试随访481', '0', '2018-12-13', '17'), ('482', '测试随访482', '0', '2018-12-13', '17'), ('483', '测试随访483', '0', '2018-12-13', '17'), ('484', '测试随访484', '0', '2018-12-13', '17'), ('485', '测试随访485', '0', '2018-12-13', '17'), ('486', '测试随访486', '0', '2018-12-13', '17'), ('487', '测试随访487', '0', '2018-12-13', '17'), ('488', '测试随访488', '0', '2018-11-02', '2'), ('489', '测试随访489', '0', '2018-11-02', '2'), ('490', '测试随访490', '0', '2018-11-08', '2'), ('491', '测试随访491', '0', '2018-11-08', '2'), ('492', '测试随访492', '0', '2018-12-07', '2'), ('493', '测试随访493', '0', '2018-12-07', '2'), ('494', '测试随访494', '0', '2018-12-20', '2'), ('495', '测试随访495', '0', '2018-12-20', '2'), ('496', '测试随访496', '0', '2018-12-20', '2'), ('497', '测试随访497', '0', '2018-12-20', '2'), ('498', '测试随访498', '0', '2018-12-20', '2'), ('499', '测试随访499', '0', '2018-12-20', '2'), ('500', '测试随访500', '0', '2018-12-20', '2'), ('501', '测试随访501', '0', '2018-12-20', '2'), ('502', '测试随访502', '0', '2018-12-20', '2'), ('503', '测试随访503', '0', '2018-12-20', '2'), ('504', '测试随访504', '0', '2018-12-15', '7'), ('505', '测试随访505', '0', '2018-12-15', '8'), ('506', '测试随访506', '0', '2018-12-26', '8'), ('507', '测试随访507', '0', '2018-12-02', '9'), ('508', '测试随访508', '0', '2018-12-15', '9'), ('509', '测试随访509', '0', '2018-12-26', '9'), ('510', '测试随访510', '0', '2018-12-15', '10'), ('511', '测试随访511', '0', '2018-12-26', '10'), ('512', '测试随访512', '0', '2018-11-12', '3'), ('513', '测试随访513', '0', '2018-11-12', '3'), ('514', '测试随访514', '0', '2018-11-12', '3'), ('515', '测试随访515', '0', '2018-12-10', '3'), ('516', '测试随访516', '0', '2018-12-10', '3'), ('517', '测试随访517', '0', '2018-12-10', '3'), ('518', '测试随访518', '0', '2018-12-10', '3'), ('519', '测试随访519', '0', '2018-12-10', '3'), ('520', '测试随访520', '0', '2018-12-10', '3'), ('521', '测试随访521', '0', '2018-12-10', '3'), ('522', '测试随访522', '0', '2018-12-10', '3'), ('523', '测试随访523', '0', '2018-10-28', '28'), ('524', '测试随访524', '0', '2018-11-26', '28'), ('525', '测试随访525', '0', '2018-11-26', '28'), ('526', '测试随访526', '0', '2018-11-26', '28'), ('527', '测试随访527', '0', '2018-11-26', '28'), ('528', '测试随访528', '0', '2018-11-26', '28'), ('529', '测试随访529', '0', '2018-11-26', '28'), ('530', '测试随访530', '0', '2018-11-26', '28'), ('531', '测试随访531', '0', '2018-11-26', '28'), ('532', '测试随访532', '0', '2018-11-26', '28'), ('533', '测试随访533', '0', '2018-11-12', '3'), ('534', '测试随访534', '0', '2018-11-12', '3'), ('535', '测试随访535', '0', '2018-11-12', '3'), ('536', '测试随访536', '0', '2018-12-10', '3'), ('537', '测试随访537', '0', '2018-12-01', '7'), ('538', '测试随访538', '0', '2018-12-26', '13'), ('539', '测试随访539', '0', '2018-12-26', '29'), ('540', '测试随访540', '0', '2018-12-25', '27'), ('541', '测试随访541', '0', '2018-12-06', '26'), ('542', '测试随访542', '0', '2018-12-02', '8'), ('543', '测试随访543', '0', '2018-12-26', '17'), ('544', '测试随访544', '0', '2018-12-27', '18'), ('545', '测试随访545', '0', '2018-12-16', '19'), ('546', '测试随访546', '0', '2018-12-27', '1'), ('547', '测试随访547', '0', '2018-12-25', '28'), ('548', '测试随访548', '0', '2018-12-26', '12'), ('549', '测试随访549', '0', '2018-12-02', '10'), ('550', '测试随访550', '0', '2018-12-26', '29'), ('551', '测试随访551', '0', '2018-12-26', '29'), ('552', '测试随访552', '0', '2018-12-25', '28'), ('553', '测试随访553', '0', '2018-12-25', '28'), ('554', '测试随访554', '0', '2018-12-25', '27'), ('555', '测试随访555', '0', '2018-12-25', '27'), ('556', '测试随访556', '0', '2018-12-25', '27'), ('557', '测试随访557', '0', '2018-12-26', '12'), ('558', '测试随访558', '0', '2018-12-26', '12'), ('559', '测试随访559', '0', '2018-12-26', '12'), ('560', '测试随访560', '0', '2018-12-26', '12'), ('561', '测试随访561', '0', '2018-12-26', '12'), ('562', '测试随访562', '0', '2018-12-26', '12'), ('563', '测试随访563', '0', '2018-12-26', '12'), ('564', '测试随访564', '0', '2018-12-26', '13'), ('565', '测试随访565', '0', '2018-12-26', '13'), ('566', '测试随访566', '0', '2018-12-26', '13'), ('567', '测试随访567', '0', '2018-12-28', '11'), ('568', '测试随访568', '0', '2018-12-28', '11'), ('569', '测试随访569', '0', '2018-12-28', '11'), ('570', '测试随访570', '0', '2018-12-28', '11'), ('571', '测试随访571', '0', '2018-12-28', '11'), ('572', '测试随访572', '0', '2018-12-28', '11'), ('573', '测试随访573', '0', '2018-12-28', '11'), ('574', '测试随访574', '0', '2018-12-28', '11'), ('575', '测试随访575', '0', '2018-12-28', '11'), ('576', '测试随访576', '0', '2018-12-28', '11'), ('577', '测试随访577', '0', '2018-12-26', '29'), ('578', '测试随访578', '0', '2018-12-26', '29'), ('579', '测试随访579', '0', '2018-12-26', '29'), ('580', '测试随访580', '0', '2018-12-26', '29'), ('581', '测试随访581', '0', '2018-12-22', '25'), ('582', '测试随访582', '0', '2018-12-22', '25'), ('583', '测试随访583', '0', '2018-12-22', '25'), ('584', '测试随访584', '0', '2018-12-22', '25'), ('585', '测试随访585', '0', '2018-12-22', '25'), ('586', '测试随访586', '0', '2018-12-22', '25'), ('587', '测试随访587', '0', '2018-12-22', '25'), ('588', '测试随访588', '0', '2018-12-22', '25'), ('589', '测试随访589', '0', '2018-12-22', '25'), ('590', '测试随访590', '0', '2018-12-22', '25'), ('591', '测试随访591', '0', '2018-12-27', '7'), ('592', '测试随访592', '0', '2018-12-26', '29'), ('593', '测试随访593', '0', '2018-10-27', '25'), ('594', '测试随访594', '0', '2018-11-10', '25'), ('595', '测试随访595', '0', '2018-11-24', '25'), ('596', '测试随访596', '0', '2018-12-08', '25'), ('597', '测试随访597', '0', '2018-12-22', '25'), ('598', '测试随访598', '0', '2018-12-28', '11'), ('599', '测试随访599', '0', '2018-12-27', '22'), ('600', '测试随访600', '0', '2018-12-25', '27'), ('601', '测试随访601', '0', '2018-12-25', '27'), ('602', '测试随访602', '0', '2018-12-25', '27'), ('603', '测试随访603', '0', '2018-12-27', '22'), ('604', '测试随访604', '0', '2018-12-27', '22'), ('605', '测试随访605', '0', '2018-12-27', '22'), ('606', '测试随访606', '0', '2018-12-27', '22'), ('607', '测试随访607', '0', '2018-12-27', '22'), ('608', '测试随访608', '0', '2018-12-27', '22'), ('609', '测试随访609', '0', '2018-12-27', '22'), ('610', '测试随访610', '0', '2018-12-27', '22'), ('611', '测试随访611', '0', '2018-12-27', '22'), ('612', '测试随访612', '0', '2018-12-27', '22'), ('613', '测试随访613', '0', '2018-12-25', '27'), ('614', '测试随访614', '0', '2018-12-25', '27'), ('615', '测试随访615', '0', '2018-12-25', '27'), ('616', '测试随访616', '0', '2018-12-26', '12'), ('617', '测试随访617', '0', '2018-12-26', '13'), ('618', '测试随访618', '0', '2018-12-26', '13'), ('619', '测试随访619', '0', '2018-12-25', '28'), ('620', '测试随访620', '0', '2018-12-25', '28'), ('621', '测试随访621', '0', '2018-12-25', '28'), ('622', '测试随访622', '0', '2018-12-27', '4'), ('623', '测试随访623', '0', '2018-12-25', '28'), ('624', '测试随访624', '0', '2018-12-25', '28'), ('625', '测试随访625', '0', '2018-12-25', '28'), ('626', '测试随访626', '0', '2018-12-25', '28'), ('627', '测试随访627', '0', '2018-10-20', '5'), ('628', '测试随访628', '0', '2018-10-02', '26'), ('629', '测试随访629', '0', '2018-11-11', '26'), ('630', '测试随访630', '0', '2018-09-30', '27'), ('631', '测试随访631', '0', '2018-10-13', '4'), ('632', '测试随访632', '0', '2018-10-26', '4'), ('633', '测试随访633', '0', '2018-09-30', '4'), ('634', '测试随访634', '0', '2018-10-15', '26'), ('635', '测试随访635', '0', '2018-10-29', '26');
COMMIT;

-- ----------------------------
--  Table structure for `t_patient`
-- ----------------------------
DROP TABLE IF EXISTS `t_patient`;
CREATE TABLE `t_patient` (
  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `NAME` varchar(20) DEFAULT NULL COMMENT '患者姓名',
  `ORGCODE` varchar(8) DEFAULT NULL COMMENT '机构编码',
  `IF_DEL` tinyint(2) DEFAULT '0' COMMENT '是否删除  1是  0否',
  `DT_FILL` date DEFAULT NULL COMMENT '建档时间',
  `DT_CREATE` timestamp NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='患者表';

-- ----------------------------
--  Records of `t_patient`
-- ----------------------------
BEGIN;
INSERT INTO `t_patient` VALUES ('1', '罗**', '44188101', '0', '2017-05-04', '2019-01-17 13:41:21'), ('2', '巫**', '44188100', '0', '2018-10-27', '2019-01-17 13:41:21'), ('3', '罗**', '44188101', '0', '2016-07-19', '2019-01-17 13:41:21'), ('4', '李**', '44188101', '0', '2016-06-07', '2019-01-17 13:41:21'), ('5', '赖**', '44188101', '0', '2016-12-03', '2019-01-17 13:41:21'), ('6', '朱**', '44188101', '0', '2017-08-01', '2019-01-17 13:41:21'), ('7', '黄**', '44188100', '0', '2012-03-21', '2019-01-17 13:41:21'), ('8', '温**', '44188100', '0', '2016-08-26', '2019-01-17 13:41:21'), ('9', '张**', '44188100', '0', '2016-06-21', '2019-01-17 13:41:21'), ('10', '张**', '44188100', '0', '2018-02-02', '2019-01-17 13:41:21'), ('11', '何**', '44188101', '0', '2018-06-05', '2019-01-17 13:41:21'), ('12', '吕**', '44188101', '0', '2016-01-19', '2019-01-17 13:41:21'), ('13', '刘**', '44188102', '0', '2015-12-23', '2019-01-17 13:41:21'), ('14', '邓**', '44188102', '0', '2016-11-22', '2019-01-17 13:41:21'), ('15', '系**', '44188102', '0', '2016-09-28', '2019-01-17 13:41:21'), ('16', '周**', '44188102', '0', '2015-12-29', '2019-01-17 13:41:21'), ('17', '邓**', '44188102', '0', '2016-06-12', '2019-01-17 13:41:21'), ('18', '陈**', '44188102', '0', '2018-07-07', '2019-01-17 13:41:21'), ('19', '丘**', '44188102', '0', '2015-08-12', '2019-01-17 13:41:21'), ('20', '刘**', '44188102', '0', '2016-02-23', '2019-01-17 13:41:21'), ('21', '廖**', '44188102', '0', '2016-06-13', '2019-01-17 13:41:21'), ('22', '石**', '44188102', '0', '2018-05-03', '2019-01-17 13:41:21'), ('23', '刘**', '44188102', '0', '2016-06-12', '2019-01-17 13:41:22'), ('24', '范**', '44188102', '0', '2016-05-30', '2019-01-17 13:41:22'), ('25', '龙**', '44188101', '0', '2016-07-11', '2019-01-17 13:41:22'), ('26', '曾**', '44188101', '0', '2017-02-17', '2019-01-17 13:41:22'), ('27', '刘**', '44188101', '0', '2015-05-25', '2019-01-17 13:41:22'), ('28', '陆**', '44188101', '0', '2017-08-27', '2019-01-17 13:41:22'), ('29', '黄**', '44188101', '0', '2016-06-24', '2019-01-17 13:41:22');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
